Progress Billing

Deacom has functionality that provides for seamless management of Progress Billing Sales, which are a series of Sales Orders linked to a Progress Billing item that has specified payments with billing amounts and due dates different than the shipments. The intent is to manage the cash receipts and billing separate from the shipments and to avoid timing issues for accounting by recognizing the costs and revenues in the same period. The system relieves inventory as it goes but relieves the cost to a progress billing account instead of COGS. Billings are made as it goes but accumulate to the progress billing account instead of a revenue account.

The header information is entered just like a normal Sales Order. Progress Billing lines reference Event Parts, which are non-stock items, created in Item Master exclusively for use on Progress Billings. Invoices are processed from the Progress Billing form. The Sales Orders associated with the Progress Billing are used to process shipments only and will not generate invoices.

System Navigation

  • Sales > Progress Billing

Progress Billing pre-filter

Field/Flag

Description

New

If clicked, opens the Edit Progress Billing form, which is used to create new orders.

Modify

If clicked, opens the Edit Progress Billing form for the selected "Progress Billing" in modify mode.

View

If clicked, generates a report using the pre-filters selected.

Report Type

Pick list used to select the kind of report to generate. Users with permission can create an unlimited number of user versions of any system report. Options are:

  • Detail
  • Invoices
  • Materials Variance
  • Profit Summary 1-2
  • Summary

Status

Pick list used to determine if all, only open, or only closed billings should be included in the report.

Date Based On

Pick list used in conjunction with the Start and End Dates to determine if results should be included based on the created or completed date.

Start Date/End Date

Used in conjunction with the "Date Based On" selection to determine the date range for which results will be generated.

Progress Billing

Filters report results for a specific Progress Billing Order.

Progress Billing Category

Filters report results for orders belonging to the selected Progress Billing Category.

Bill-to Company

Filters report results for orders created for the selected Bill-to Company.

Ship-to Company

Filters report results for orders created for the selected Ship-to Company.

Facility

Filters report results for orders belonging to the selected Facility.

Facility Group

Filters report results for orders belonging to a Facility in the selected Facility Group.

Sales Rep

Filters report results for orders with the selected Sales Rep assigned.

Sales Group

Filters report results for orders with Sales Reps that belong to the selected Sales Group.

Sales Search 1-5

Search fields used to select user-defined options.

  • Captions for these fields are defined in System > Options > Sales 2 tab.

Display Currency

Search field used to select the Currency in which results should be displayed.

Currency Filter

Filters report results for orders created for the selected Currency.

Project

Filters report results for orders belonging to the selected Project.

Edit Progress Billing form

Opened via the "New" or "Modify" buttons on the Progress Billing Pre-Filter.

Field/Flag

Description

Add

If clicked, opens the Edit Billing Event form, which is used to select an Event Part, specify an amount, and enter billing details.

Modify

If clicked, opens the Edit Billing Event form for the selected line.

Delete

If clicked, deletes the currently selected line.

Sort

If clicked, allows the user to reorder the existing lines.

View Orders

If clicked, generates a Progress Billing Management report for Sales Orders linked to the selected Progress Billing order.

Close-Out

If clicked, allows the user to select a date to use to close the Progress Billing order and populates the "Completed" field with the selected date.

Invoice

If clicked, allows the user to select a date to use then generates an invoice and a Sales Order for the amounts specified in the "Bill Now" column.

Copy Billing

If clicked, allows the user to copy the billing structure of a previous Progress Billing order.

Billing ID

Displays the sequential, system-generated number.

Created

Displays the date the Progress Billing order was established.

Bill-to Company

Search field used to select the Bill-to Company for the order.

Ship-to Company

Search field used to select the Ship-to Company for the order.

Facility

Indicates the Facility from which the order will ship.

Terms

Indicates the Terms with which the order will be billed and payment should be received.

Category

Indicates the Progress Billing Category to which this order belongs.

Currency

Indicates the Currency in which this order will be billed.

Currency Conversion

Displays the "Rate" that is used to convert the selected Currency to USD, as defined on the Currency record.

Bill-to PO

Defines the Purchase Order number sent from the Bill-to Company, if one was provided.

Based On

Indicates the Sales Order to which this Progress Billing order relates.

Description

Displays a description of the order.

Quoted Margin

Defines the percentage additional to the total amount that the customer will pay.

Notes

Memo field used to store notes regarding the order.

Completed

Displays the date that the Progress Billing order was closed out.

Remaining Amount

Displays the remaining amount to be paid by the customer.

  • Calculates as the sum of the Amounts minus the sum of the Amt Billed.

Edit Billing Event form

Field/Flag

Description

Event Part Number

Search field used to select a Part not flagged as "Stocked" on its Item Master Properties tab that represents this billing.

Amount

Defines the dollar amount that will be charged for the selected Part.

Bill Now

Defines the portion of the "Amount" that will be billed to the customer upon saving the Progress Billing and entering the first linked Sales Order.

Retainage %

Defines the percentage of the "Bill Now" amount that will be retained, or withheld, from each payment, until a pre-determined date.

Retainage

Displays the dollars that will be retained.

  • Calculates as the "Bill Now" amount multiplied by the "Retainage %".

Scheduled

Defines the date the selected Billing Event will be charged.

Notes

Memo field used for miscellaneous notes relating to the Billing Event selected.

Related Pages